Final Project
# Summary (At Least 5 values)
Introduction
As a result of smartphones slowly becoming a crucial part of modern day society, the demand for mobile applications has increased greatly. The number of apps on the App Stores has been expanding at an increased rate due to app developers constantly publishing apps to meet demand. According to Apple and Google, in 2019, there are 2.2 million and 2.8 million apps available for download on their respective App Stores. We have downloaded two different datasets “Mobile App Store” (collected July 2017) and “Google Play Store Apps”(April 2019). These two data sets contain information regarding apps on the Apple App store and Google Play store such as price, rating, genre, size, and content rating. People that own a smartphone device have their own unique conglomeration of different types of apps based on their interests and personality, making it more important to find trends in mobile apps to aid in the creation of successful apps. We will be analyzing and comparing the previously mentioned data sets to determine what makes an app successful on the different app stores. This data will create useful mobile app analytics to help developers understand existing strategies and categories that drive growth and retention of future app users.
Summary (At Least 5 values)
Table of Aggregated Data
Google Playstore
| Category | avg_rating | avg_price | count |
|---|---|---|---|
| EDUCATION | 4.347935 | 0.2227142 | 32253 |
| BOOKS_AND_REFERENCE | 4.478069 | 0.2425901 | 20818 |
| TOOLS | 4.140973 | 0.2546167 | 20677 |
| ENTERTAINMENT | 4.259305 | 0.1145896 | 19921 |
| MUSIC_AND_AUDIO | 4.434871 | 0.0831823 | 17453 |
| LIFESTYLE | 4.300007 | 0.2481824 | 14574 |
| PERSONALIZATION | 4.439195 | 0.1149543 | 10183 |
| FINANCE | 4.044319 | 0.1469723 | 9727 |
| BUSINESS | 4.148258 | 0.1436264 | 9712 |
| PRODUCTIVITY | 4.171951 | 0.2528216 | 8605 |
| NEWS_AND_MAGAZINES | 4.239920 | 0.0156262 | 7538 |
| HEALTH_AND_FITNESS | 4.204990 | 0.1901624 | 7144 |
| PHOTOGRAPHY | 4.168991 | 0.1201207 | 6958 |
| TRAVEL_AND_LOCAL | 4.129044 | 0.1422720 | 6272 |
| SPORTS | 4.287010 | 0.8349896 | 5303 |
| COMMUNICATION | 4.244688 | 0.1218440 | 5206 |
| SHOPPING | 4.203132 | 0.0172765 | 5078 |
| SOCIAL | 4.364846 | 0.0384765 | 4575 |
| MAPS_AND_NAVIGATION | 4.024102 | 0.2833386 | 3798 |
| MEDICAL | 4.235834 | 0.9594763 | 3571 |
| GAME_PUZZLE | 4.355070 | 0.3645550 | 3337 |
| FOOD_AND_DRINK | 4.311318 | 0.0801187 | 3034 |
| VIDEO_PLAYERS | 4.056594 | 0.1840687 | 2502 |
| GAME_CASUAL | 4.238262 | 0.2047247 | 2216 |
| GAME_ARCADE | 4.270308 | 0.2608960 | 2154 |
| AUTO_AND_VEHICLES | 4.121941 | 0.4197469 | 2015 |
| GAME_EDUCATIONAL | 4.256553 | 0.4003596 | 1891 |
| ART_AND_DESIGN | 4.229947 | 0.1025301 | 1743 |
| GAME_SIMULATION | 4.207407 | 0.5860224 | 1516 |
| WEATHER | 4.193114 | 0.2626455 | 1512 |
| GAME_ACTION | 4.248715 | 0.3614674 | 1363 |
| GAME_CARD | 4.259975 | 0.3127719 | 1039 |
| GAME_ADVENTURE | 4.319100 | 1.3447160 | 986 |
| GAME_ROLE_PLAYING | 4.325505 | 1.3371708 | 972 |
| BEAUTY | 4.302155 | 0.0387979 | 940 |
| GAME_BOARD | 4.252069 | 0.6110855 | 912 |
| HOUSE_AND_HOME | 4.036159 | 0.0358857 | 875 |
| GAME_WORD | 4.352840 | 0.0796620 | 858 |
| GAME_STRATEGY | 4.278548 | 0.7246732 | 811 |
| GAME_TRIVIA | 4.214058 | 0.2640225 | 711 |
| GAME_SPORTS | 4.160957 | 0.4867137 | 709 |
| GAME_RACING | 4.209314 | 0.2355977 | 686 |
| LIBRARIES_AND_DEMO | 4.215884 | 0.1347761 | 603 |
| EVENTS | 4.325351 | 0.0041402 | 599 |
| PARENTING | 4.335070 | 0.1278130 | 599 |
| COMICS | 4.267838 | 0.1052361 | 487 |
| GAME_CASINO | 4.360730 | 0.0240060 | 332 |
| DATING | 4.046594 | 0.0782353 | 306 |
| GAME_MUSIC | 4.109844 | 0.2694421 | 233 |
This table contains information that was calculated such as the average rating per category, average price per category and how many applications per category for the Google Playstore. From this data we can see that “EDUCATION” contains the most number of applications for the specified category containing 32253 different applications.
Apple Store
| prime_genre | avg_rating | avg_price | count |
|---|---|---|---|
| Games | 3.685008 | 1.4329234 | 3862 |
| Entertainment | 3.246729 | 0.8897009 | 535 |
| Education | 3.376380 | 4.0282340 | 453 |
| Photo & Video | 3.800860 | 1.4732951 | 349 |
| Utilities | 3.278226 | 1.6476210 | 248 |
| Health & Fitness | 3.700000 | 1.9164444 | 180 |
| Productivity | 4.005618 | 4.3305618 | 178 |
| Social Networking | 2.985030 | 0.3398802 | 167 |
| Lifestyle | 2.805556 | 0.8854167 | 144 |
| Music | 3.978261 | 4.8354348 | 138 |
| Shopping | 3.540984 | 0.0163115 | 122 |
| Sports | 2.982456 | 0.9530702 | 114 |
| Book | 2.477679 | 1.7905357 | 112 |
| Finance | 2.432692 | 0.4211538 | 104 |
| Travel | 3.376543 | 1.1203704 | 81 |
| News | 2.980000 | 0.5177333 | 75 |
| Weather | 3.597222 | 1.6054167 | 72 |
| Reference | 3.453125 | 4.8368750 | 64 |
| Food & Drink | 3.182540 | 1.5523810 | 63 |
| Business | 3.745614 | 5.1163158 | 57 |
| Navigation | 2.684783 | 4.1247826 | 46 |
| Medical | 3.369565 | 8.7760870 | 23 |
| Catalogs | 2.100000 | 0.7990000 | 10 |
This table contains information that was calculated such as the average rating per category, average price per category and how many applications per category for the Apple Store. From this data we can see that “Games” contains the most number of applications for the specified category containing 3862 different applications.
Visualizations
Plot 1(Amount of Applications per Category)
